home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vbusNotProbed.sql < prev    next >
Text File  |  2000-05-12  |  407b  |  13 lines
  1. /* 
  2. for each date when probing occurred, lists the buses which were NOT probed
  3. */
  4. create or replace view vbusnotprobed as
  5. select farebox.glid , bus.bus_id, 
  6.     vprobedates.tpdate
  7. from  vprobedates, 
  8.     farebox, bus
  9. where not exists (Select probehist.farebox_glid from probehist
  10.         where tpdate  = trunc(probehist.pdate) and
  11.             probehist.farebox_glid = farebox.glid)
  12.     and farebox.location = bus.glid;
  13.